﻿CREATE TABLE [dbo].[BoardGameScenario]
(
	[BoardGameScenarioId] INT NOT NULL identity(1,1),
	[BoardGameId] int not null,
	[Name] NVARCHAR(128) NOT NULL, 
	[CreatedBy] NVARCHAR(256) NOT NULL, 
	[CreateDate] DATETIME NOT NULL, 
	[ModifiedBy] NVARCHAR(256) NOT NULL, 
	[ModifyDate] DATETIME NOT NULL, 
	constraint PK_BoardGameScenario primary key (BoardGameScenarioId),
	constraint FK_BoardGameScenario_IsOf_BoardGame FOREIGN KEY (BoardGameId)
		references BoardGame ([BoardGameId]),
)
go
create unique index UX_BoardGameScenario_BoardGameId_Name on dbo.BoardGameScenario (BoardGameId, Name)
go
create index IX_BoardGameScenario_BoardGameId on dbo.BoardGameScenario (BoardGameId)
go

